Skip to content
Discussions
Topics
Support
Product Ideas
Help & Learning
Sign in
Try Smartsheet
Kimberley O
Kimberley O
Clear
Search
Loading
Home
›
Kimberley O
›
Awesome
Kimberley O
·
Transition Manager
·
✭✭✭
Overview
Overview
Roles
Member
Badges
8
About Me
About Me
Title
Transition Manager
Area of Expertise
Project Management
How I Use Smartsheet
For tracking projects
Analytics
11
Posts
96
Visits
286
Points
May 12, 2023
Join Date
Jul 2, 2024
Last Active
Reactions
Awesome 1
1
Activity
Discussions
5
Comments
6
Re: Using IF/THEN to Create a Password
Kimberley O
05/30/24
As soon as I hit "Send" on this question, I figured it out! The correct formula is: =IF([Return by]@row = "Email", RIGHT([DL #]@row, 5) + LEFT([Last Name]@row, 4) + [Year of birth…
1
·
Activity
Discussions
5
Comments
6
Badges